Дана таблица orders с колонками order_id, customer_id, order_date, total_amount. Какой из следующих SQL запросов вернет топ-3 месяца с наибольшим количеством заказов?
A) SELECT MONTH(order_date) AS month, SUM(total_amount) AS total_order_amount FROM orders GROUP BY month ORDER BY total_order_amount DESC LIMIT 3;
B) SELECT EXTRACT(MONTH FROM order_date) AS month, SUM(total_amount) AS total_order_amount FROM orders GROUP BY month ORDER BY total_order_amount DESC LIMIT 3;
C) SELECT DATE_TRUNC('month', order_date) AS month, SUM(total_amount) AS total_order_amount FROM orders GROUP BY month ORDER BY total_order_amount DESC LIMIT 3;
D) SELECT STRFTIME('%Y-%m', order_date) AS month, SUM(total_amount) AS total_order_amount FROM orders GROUP BY month ORDER BY total_order_amount DESC LIMIT 3;
Дана таблица orders с колонками order_id, customer_id, order_date, total_amount. Какой из следующих SQL запросов вернет топ-3 месяца с наибольшим количеством заказов?
A) SELECT MONTH(order_date) AS month, SUM(total_amount) AS total_order_amount FROM orders GROUP BY month ORDER BY total_order_amount DESC LIMIT 3;
B) SELECT EXTRACT(MONTH FROM order_date) AS month, SUM(total_amount) AS total_order_amount FROM orders GROUP BY month ORDER BY total_order_amount DESC LIMIT 3;
C) SELECT DATE_TRUNC('month', order_date) AS month, SUM(total_amount) AS total_order_amount FROM orders GROUP BY month ORDER BY total_order_amount DESC LIMIT 3;
D) SELECT STRFTIME('%Y-%m', order_date) AS month, SUM(total_amount) AS total_order_amount FROM orders GROUP BY month ORDER BY total_order_amount DESC LIMIT 3;
Ответить на вопрос можно ниже ⬇️
BY SQL для тестировщика
Warning: Undefined variable $i in /var/www/tg-me/post.php on line 283
The messaging service and social-media platform owes creditors roughly $700 million by the end of April, according to people briefed on the company’s plans and loan documents viewed by The Wall Street Journal. At the same time, Telegram Group Inc. must cover rising equipment and bandwidth expenses because of its rapid growth, despite going years without attempting to generate revenue.
Export WhatsApp stickers to Telegram on iPhone
You can’t. What you can do, though, is use WhatsApp’s and Telegram’s web platforms to transfer stickers. It’s easy, but might take a while.Open WhatsApp in your browser, find a sticker you like in a chat, and right-click on it to save it as an image. The file won’t be a picture, though—it’s a webpage and will have a .webp extension. Don’t be scared, this is the way. Repeat this step to save as many stickers as you want.Then, open Telegram in your browser and go into your Saved messages chat. Just as you’d share a file with a friend, click the Share file button on the bottom left of the chat window (it looks like a dog-eared paper), and select the .webp files you downloaded. Click Open and you’ll see your stickers in your Saved messages chat. This is now your sticker depository. To use them, forward them as you would a message from one chat to the other: by clicking or long-pressing on the sticker, and then choosing Forward.
